ں̨ݿ


CREATE TABLE `data_bbsnews` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `author` varchar(15) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  `sort` varchar(50) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `views` smallint(6) unsigned NOT NULL default '0',
  `replys` smallint(6) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `replytime` int(10) unsigned NOT NULL default '0',
  `attachment` varchar(50) NOT NULL default '',
  `color` varchar(10) NOT NULL default '',
  `topped` tinyint(1) NOT NULL default '0',
  `downloads` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `dateline` (`dateline`)
) TYPE=MyISAM;
CREATE TABLE `data_bbsnewsreply` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `nid` mediumint(8) unsigned NOT NULL default '0',
  `author` varchar(15) NOT NULL default '',
  `authorip` varchar(15) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `dateline` int(10) NOT NULL default '0',
  KEY `id` (`id`),
  KEY `nid` (`nid`)
) TYPE=MyISAM;



DROP TABLE IF EXISTS data_bbsnews;
CREATE TABLE data_bbsnews (
  id mediumint(8) unsigned NOT NULL auto_increment,
  author varchar(15) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  sort varchar(50) NOT NULL default '',
  message mediumtext NOT NULL,
  views smallint(6) unsigned NOT NULL default '0',
  replys smallint(6) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  replytime int(10) unsigned NOT NULL default '0',
  attachment varchar(50) NOT NULL default '',
  color varchar(10) NOT NULL default '',
  topped tinyint(1) NOT NULL default '0',
  downloads smallint(6) NOT NULL default '0',
  nj varchar(50) NOT NULL default '',
  wz varchar(50) NOT NULL default '',
  km varchar(50) NOT NULL default '',
  gq varchar(50) NOT NULL default '',
  lxdh varchar(20) NOT NULL default '',
  xl varchar(50) NOT NULL default '',
  lxr varchar(10) NOT NULL default '',
  xb char(2) NOT NULL default '',
  bc varchar(20) NOT NULL default '',
  lxqq varchar(20) NOT NULL default '',
  yxq varchar(20) NOT NULL default '',
  gzdw varchar(50) NOT NULL default '',
  mqsf varchar(50) NOT NULL default '',
  jsfs varchar(50) NOT NULL default '',
  jxsj varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  xsbz char(1) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY dateline (dateline)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
